<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link type="text/css" href="../../bogstyle.css" rel="stylesheet" media="screen" />
<title>BOG - Best Online Games</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php 
	include '../../functions.php';
	
	$game = "kickoff";
	
	//alte Sessions löschen
	$t = time()-600;
	$sql = "DELETE FROM sessions WHERE zeit < '".$t."'";
	$result = mysql_db_query('mobaras_bogg',$sql);
    if(!$result) echo 'Fehler-Nr. ' . mysql_errno() . ' - ' . mysql_error();

?>
</head>

<body>
<div id="container">
	<div id="banner">
		<?php show_banner(2); ?>
	</div>
	<div id="left">
		<?php show_navi(2); ?>
	</div>
	<div id="content">
		<p style="font-size:110%;font-weight:bold">Offene KickOff-Spiele</p>
		<?php
		
		//Offene Sessions anzeigen
		$sql = "SELECT * FROM sessions WHERE game = '".$game."'";
		$result = mysql_db_query('mobaras_bogg',$sql);
	    if(!$result) echo 'Fehler-Nr. ' . mysql_errno() . ' - ' . mysql_error();
	    
	    echo "<table align=center>";
		
	    while($spiel = mysql_fetch_object($result)){
	    	echo "<tr><td style=\"border-right-width:thin;border-right-style:solid;border-right-color:black\">
					<a href=\"enterSession.php?ipAdd=".$spiel->ipAdd."&port=".$spiel->port."\">".$spiel->name."</a>
	    		  </td><td>".$spiel->ipAdd."</td></tr>";
	    }
	    echo "</table>";
	    ?>
	</div>
	<div id="right">
	</div>
	<div id="footer">BOG  - Nur die besten OnlineGames</div>
</div>
</body>
</html>









<?php
	
	
	
?>

